﻿CREATE TABLE [app].[Logins] (
    [Id]                      BIGINT           IDENTITY (1, 1) NOT NULL,
    [LoginName]               NVARCHAR (50)    NOT NULL,
    [PasswordSalt]            NVARCHAR (2048)  NOT NULL,
    [PasswordHash]            NVARCHAR (2048)  NOT NULL,
    [Guid]                    UNIQUEIDENTIFIER CONSTRAINT [DF_Logins_Guid] DEFAULT (newid()) NOT NULL,
    [CreatedDateTime]         DATETIME         NOT NULL,
    [PasswordChangedDateTime] DATETIME         NULL,
    CONSTRAINT [PK__Logins__3214EC0738996AB5] PRIMARY KEY CLUSTERED ([Id] ASC)
);



